YData Profiling Report

Brought to you by YData

Dataset statistics

Number of variables	16
Number of observations	294536
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	105.3 MiB
Average record size in memory	375.0 B

Variable types

DateTime	1
Text	2
Numeric	11
Categorical	1
Boolean	1

Alerts

`congestion_level` has 11275 (3.8%) zeros	Zeros
`incident_reports` has 25270 (8.6%) zeros	Zeros

Reproduction

Analysis started	2025-04-03 09:58:03.457755
Analysis finished	2025-04-03 09:58:22.889411
Duration	19.43 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

date
Date

Distinct	952
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	2.2 MiB

Minimum	2022-01-01 00:00:00
Maximum	2024-08-09 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

area_name
Text

Distinct	288
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	16.5 MiB

Length

Max length	27
Median length	20
Mean length	9.6796249
Min length	3

Characters and Unicode

Total characters	2850998
Distinct characters	62
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Gomti Nagar
2nd row	Indira Nagar
3rd row	Alambagh
4th row	Rajajipuram
5th row	Arjunganj

Value	Count	Frequency (%)
nagar	28560	6.8%
sector	9520	2.3%
area	3808	0.9%
colony	3808	0.9%
park	3808	0.9%
road	3405	0.8%
bandra	2856	0.7%
varachha	2856	0.7%
connaught	2856	0.7%
more	2856	0.7%
Other values (327)	356016	84.7%

Most occurring characters

Value	Count	Frequency (%)
a	562085	19.7%
r	227175	8.0%
n	163391	5.7%
i	145604	5.1%
h	127122	4.5%
	125813	4.4%
e	114552	4.0%
o	97665	3.4%
d	92699	3.3%
l	89488	3.1%
Other values (52)	1105404	38.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2850998	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	562085	19.7%
r	227175	8.0%
n	163391	5.7%
i	145604	5.1%
h	127122	4.5%
	125813	4.4%
e	114552	4.0%
o	97665	3.4%
d	92699	3.3%
l	89488	3.1%
Other values (52)	1105404	38.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2850998	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	562085	19.7%
r	227175	8.0%
n	163391	5.7%
i	145604	5.1%
h	127122	4.5%
	125813	4.4%
e	114552	4.0%
o	97665	3.4%
d	92699	3.3%
l	89488	3.1%
Other values (52)	1105404	38.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2850998	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	562085	19.7%
r	227175	8.0%
n	163391	5.7%
i	145604	5.1%
h	127122	4.5%
	125813	4.4%
e	114552	4.0%
o	97665	3.4%
d	92699	3.3%
l	89488	3.1%
Other values (52)	1105404	38.8%

road_name
Text

Distinct	304
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	17.9 MiB

Length

Max length	40
Median length	27
Mean length	14.619683
Min length	3

Characters and Unicode

Total characters	4306023
Distinct characters	64
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Shaheed Path
2nd row	Faizabad Road
3rd row	Kanpur Road (NH-27)
4th row	Hardoi Road
5th row	Sultanpur Road

Value	Count	Frequency (%)
road	226732	31.5%
marg	16184	2.3%
main	11874	1.7%
path	10472	1.5%
ring	8568	1.2%
bypass	8568	1.2%
nagar	8568	1.2%
high	4760	0.7%
new	4760	0.7%
highway	4760	0.7%
Other values (380)	413691	57.5%

Most occurring characters

Value	Count	Frequency (%)
a	746128	17.3%
	424401	9.9%
o	313130	7.3%
d	311600	7.2%
R	260052	6.0%
r	232773	5.4%
i	188734	4.4%
n	160323	3.7%
h	151415	3.5%
e	129567	3.0%
Other values (54)	1387900	32.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4306023	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	746128	17.3%
	424401	9.9%
o	313130	7.3%
d	311600	7.2%
R	260052	6.0%
r	232773	5.4%
i	188734	4.4%
n	160323	3.7%
h	151415	3.5%
e	129567	3.0%
Other values (54)	1387900	32.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4306023	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	746128	17.3%
	424401	9.9%
o	313130	7.3%
d	311600	7.2%
R	260052	6.0%
r	232773	5.4%
i	188734	4.4%
n	160323	3.7%
h	151415	3.5%
e	129567	3.0%
Other values (54)	1387900	32.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4306023	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	746128	17.3%
	424401	9.9%
o	313130	7.3%
d	311600	7.2%
R	260052	6.0%
r	232773	5.4%
i	188734	4.4%
n	160323	3.7%
h	151415	3.5%
e	129567	3.0%
Other values (54)	1387900	32.2%

traffic_volume
Real number (ℝ)

Distinct	59505
Distinct (%)	20.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22583.157

Minimum	500
Maximum	97282
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.2 MiB

Quantile statistics

Minimum	500
5-th percentile	2071.75
Q1	8912
median	20149
Q3	31956.25
95-th percentile	52281.25
Maximum	97282
Range	96782
Interquartile range (IQR)	23044.25

Descriptive statistics

Standard deviation	17149.587
Coefficient of variation (CV)	0.75939724
Kurtosis	1.3946694
Mean	22583.157
Median Absolute Deviation (MAD)	11474
Skewness	1.1195165
Sum	6.6515526 × 10⁹
Variance	2.9410832 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4124	28	< 0.1%
3998	26	< 0.1%
2982	25	< 0.1%
3735	25	< 0.1%
2903	25	< 0.1%
3360	25	< 0.1%
4906	25	< 0.1%
3396	24	< 0.1%
4443	24	< 0.1%
4795	24	< 0.1%
Other values (59495)	294285	99.9%

Value	Count	Frequency (%)
500	10	< 0.1%
501	13	< 0.1%
502	9	< 0.1%
503	7	< 0.1%
504	6	< 0.1%
505	9	< 0.1%
506	9	< 0.1%
507	11	< 0.1%
508	5	< 0.1%
509	3	< 0.1%

Value	Count	Frequency (%)
97282	1	< 0.1%
95342	1	< 0.1%
94348	1	< 0.1%
94037	1	< 0.1%
93007	1	< 0.1%
92214	1	< 0.1%
92182	1	< 0.1%
91639	1	< 0.1%
91596	1	< 0.1%
91468	1	< 0.1%

average_speed
Real number (ℝ)

Distinct	294172
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.164683

Minimum	7.1448462
Maximum	89.790843
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.2 MiB

Quantile statistics

Minimum	7.1448462
5-th percentile	15.060228
Q1	28.065425
median	37.971341
Q3	48.065283
95-th percentile	60.959478
Maximum	89.790843
Range	82.645996
Interquartile range (IQR)	19.999858

Descriptive statistics

Standard deviation	13.717873
Coefficient of variation (CV)	0.35943894
Kurtosis	-0.70076642
Mean	38.164683
Median Absolute Deviation (MAD)	10.002532
Skewness	0.040373684
Sum	11240873
Variance	188.18005
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20	365	0.1%
25.39954748	1	< 0.1%
52.13222941	1	< 0.1%
50.16891983	1	< 0.1%
47.07221981	1	< 0.1%
62.39131014	1	< 0.1%
59.10989855	1	< 0.1%
64.92398498	1	< 0.1%
48.09766187	1	< 0.1%
51.4767105	1	< 0.1%
Other values (294162)	294162	99.9%

Value	Count	Frequency (%)
7.144846195	1	< 0.1%
10.00009144	1	< 0.1%
10.00016861	1	< 0.1%
10.00035425	1	< 0.1%
10.00045535	1	< 0.1%
10.00124588	1	< 0.1%
10.00265304	1	< 0.1%
10.00273065	1	< 0.1%
10.00321571	1	< 0.1%
10.00417376	1	< 0.1%

Value	Count	Frequency (%)
89.79084251	1	< 0.1%
82.12795345	1	< 0.1%
81.94472677	1	< 0.1%
80.48682398	1	< 0.1%
80.23139882	1	< 0.1%
78.76633909	1	< 0.1%
76.82378504	1	< 0.1%
75.86281133	1	< 0.1%
75.53032677	1	< 0.1%
75.12173833	1	< 0.1%

travel_time_index
Real number (ℝ)

Distinct	97310
Distinct (%)	33.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.5863233

Minimum	1.0000385
Maximum	10
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.2 MiB

Quantile statistics

Minimum	1.0000385
5-th percentile	1.35
Q1	1.89
median	2.5
Q3	3.0179388
95-th percentile	4
Maximum	10
Range	8.9999615
Interquartile range (IQR)	1.1279388

Descriptive statistics

Standard deviation	1.0498182
Coefficient of variation (CV)	0.40591142
Kurtosis	9.5615748
Mean	2.5863233
Median Absolute Deviation (MAD)	0.56
Skewness	2.3356787
Sum	761765.33
Variance	1.1021182
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.5	5794	2.0%
2.27	893	0.3%
2.4	886	0.3%
2.35	881	0.3%
2.23	878	0.3%
2.48	874	0.3%
2.58	859	0.3%
2.42	859	0.3%
2.25	858	0.3%
2.28	855	0.3%
Other values (97300)	280899	95.4%

Value	Count	Frequency (%)
1.000038548	1	< 0.1%
1.000489375	1	< 0.1%
1.00090187	1	< 0.1%
1.000948559	1	< 0.1%
1.000986878	1	< 0.1%
1.001029193	1	< 0.1%
1.001208349	1	< 0.1%
1.001591218	1	< 0.1%
1.001674977	1	< 0.1%
1.001749593	1	< 0.1%

Value	Count	Frequency (%)
10	2	< 0.1%
9.99	2	< 0.1%
9.98	1	< 0.1%
9.97	1	< 0.1%
9.96	4	< 0.1%
9.95	5	< 0.1%
9.94	4	< 0.1%
9.93	7	< 0.1%
9.92	8	< 0.1%
9.91	5	< 0.1%

congestion_level
Real number (ℝ)

Zeros

Distinct	251987
Distinct (%)	85.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	59.184488

Minimum	0
Maximum	480.27
Zeros	11275
Zeros (%)	3.8%
Negative	0
Negative (%)	0.0%
Memory size	2.2 MiB

Quantile statistics

Minimum	0
5-th percentile	5.7789341
Q1	35.948497
median	54.117049
Q3	74.25
95-th percentile	113.5125
Maximum	480.27
Range	480.27
Interquartile range (IQR)	38.301503

Descriptive statistics

Standard deviation	40.512428
Coefficient of variation (CV)	0.68451091
Kurtosis	13.81845
Mean	59.184488
Median Absolute Deviation (MAD)	19.123699
Skewness	2.6484187
Sum	17431962
Variance	1641.2568
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	11277	3.8%
0	11275	3.8%
43.5	11	< 0.1%
92.98	10	< 0.1%
76.71	10	< 0.1%
104.93	9	< 0.1%
115.49	9	< 0.1%
88.41	9	< 0.1%
65.84	9	< 0.1%
71.18	9	< 0.1%
Other values (251977)	271908	92.3%

Value	Count	Frequency (%)
0	11275	3.8%
0.002914358794	1	< 0.1%
0.003605227847	1	< 0.1%
0.005986990683	1	< 0.1%
0.006835966621	1	< 0.1%
0.01226125943	1	< 0.1%
0.01371415267	1	< 0.1%
0.01404544642	1	< 0.1%
0.01448273965	1	< 0.1%
0.01452404526	1	< 0.1%

Value	Count	Frequency (%)
480.27	1	< 0.1%
479.93	1	< 0.1%
478.21	1	< 0.1%
477.99	1	< 0.1%
477.21	1	< 0.1%
472.85	1	< 0.1%
469	1	< 0.1%
465.08	1	< 0.1%
464.22	2	< 0.1%
460.67	1	< 0.1%

road_capacity_utilization
Real number (ℝ)

Distinct	111330
Distinct (%)	37.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	58.732619

Minimum	0.40000564
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.2 MiB

Quantile statistics

Minimum	0.40000564
5-th percentile	0.71010003
Q1	48.127346
median	63.23
Q3	78.72
95-th percentile	95.46
Maximum	100
Range	99.599994
Interquartile range (IQR)	30.592654

Descriptive statistics

Standard deviation	27.779773
Coefficient of variation (CV)	0.47298714
Kurtosis	-0.022274516
Mean	58.732619
Median Absolute Deviation (MAD)	15.34
Skewness	-0.85472825
Sum	17298871
Variance	771.71581
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	6586	2.2%
64.24	61	< 0.1%
66.29	59	< 0.1%
70.38	58	< 0.1%
74.46	57	< 0.1%
79.35	56	< 0.1%
80.3	55	< 0.1%
64.46	55	< 0.1%
79.6	54	< 0.1%
60.58	54	< 0.1%
Other values (111320)	287441	97.6%

Value	Count	Frequency (%)
0.4000056382	1	< 0.1%
0.4000232341	1	< 0.1%
0.4000810961	1	< 0.1%
0.4000859224	1	< 0.1%
0.4000954801	1	< 0.1%
0.4000971946	1	< 0.1%
0.4000981106	1	< 0.1%
0.4001139728	1	< 0.1%
0.4001192132	1	< 0.1%
0.4001347152	1	< 0.1%

Value	Count	Frequency (%)
100	6586	2.2%
99.99911308	1	< 0.1%
99.99727229	1	< 0.1%
99.99698556	1	< 0.1%
99.99429011	1	< 0.1%
99.99368359	1	< 0.1%
99.99284056	1	< 0.1%
99.99259095	1	< 0.1%
99.99148888	1	< 0.1%
99.99	5	< 0.1%

incident_reports
Real number (ℝ)

Zeros

Distinct	20
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.6667979

Minimum	0
Maximum	19
Zeros	25270
Zeros (%)	8.6%
Negative	0
Negative (%)	0.0%
Memory size	2.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	5
Q3	9
95-th percentile	13
Maximum	19
Range	19
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	4.0009588
Coefficient of variation (CV)	0.7060352
Kurtosis	-0.5641835
Mean	5.6667979
Median Absolute Deviation (MAD)	3
Skewness	0.46879224
Sum	1669076
Variance	16.007672
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
2	27069	9.2%
3	26827	9.1%
1	26026	8.8%
4	26008	8.8%
0	25270	8.6%
5	24869	8.4%
6	21573	7.3%
7	20635	7.0%
8	20413	6.9%
9	20171	6.8%
Other values (10)	55675	18.9%

Value	Count	Frequency (%)
0	25270	8.6%
1	26026	8.8%
2	27069	9.2%
3	26827	9.1%
4	26008	8.8%
5	24869	8.4%
6	21573	7.3%
7	20635	7.0%
8	20413	6.9%
9	20171	6.8%

Value	Count	Frequency (%)
19	476	0.2%
18	483	0.2%
17	476	0.2%
16	470	0.2%
15	493	0.2%
14	8074	2.7%
13	8250	2.8%
12	8107	2.8%
11	14553	4.9%
10	14293	4.9%

environmental_impact
Real number (ℝ)

Distinct	116422
Distinct (%)	39.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	77.138631

Minimum	20.001206
Maximum	551.04
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.2 MiB

Quantile statistics

Minimum	20.001206
5-th percentile	31.27
Q1	51.97
median	65.850247
Q3	79.13
95-th percentile	155.437
Maximum	551.04
Range	531.03879
Interquartile range (IQR)	27.16

Descriptive statistics

Standard deviation	60.736399
Coefficient of variation (CV)	0.78736682
Kurtosis	13.071695
Mean	77.138631
Median Absolute Deviation (MAD)	13.560247
Skewness	3.6112744
Sum	22720104
Variance	3688.9101
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
79.73	60	< 0.1%
59.45	60	< 0.1%
66.18	58	< 0.1%
71.31	58	< 0.1%
76.24	58	< 0.1%
71.15	58	< 0.1%
73.92	57	< 0.1%
55.78	57	< 0.1%
79.57	57	< 0.1%
67.23	57	< 0.1%
Other values (116412)	293956	99.8%

Value	Count	Frequency (%)
20.00120634	1	< 0.1%
20.00254699	1	< 0.1%
20.00269334	1	< 0.1%
20.00270382	1	< 0.1%
20.0030394	1	< 0.1%
20.00415198	1	< 0.1%
20.00628142	1	< 0.1%
20.00677726	1	< 0.1%
20.00785538	1	< 0.1%
20.00887909	1	< 0.1%

Value	Count	Frequency (%)
551.04	1	< 0.1%
549.24	1	< 0.1%
502.08	1	< 0.1%
452.865	1	< 0.1%
444.86	1	< 0.1%
439.54	1	< 0.1%
436.655	1	< 0.1%
436.545	1	< 0.1%
435.425	1	< 0.1%
428.37	1	< 0.1%

public_transport_usage
Real number (ℝ)

Distinct	98033
Distinct (%)	33.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.7885491

Minimum	0.10001059
Maximum	98.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.2 MiB

Quantile statistics

Minimum	0.10001059
5-th percentile	0.26791753
Q1	0.4169633
median	0.55651105
Q3	0.69034585
95-th percentile	54.402927
Maximum	98.5
Range	98.399989
Interquartile range (IQR)	0.27338255

Descriptive statistics

Standard deviation	17.303495
Coefficient of variation (CV)	2.548924
Kurtosis	5.4452233
Mean	6.7885491
Median Absolute Deviation (MAD)	0.13672249
Skewness	2.6193609
Sum	1999472.1
Variance	299.41096
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.44	4252	1.4%
0.69	4245	1.4%
0.66	4215	1.4%
0.57	4212	1.4%
0.5	4199	1.4%
0.68	4195	1.4%
0.51	4186	1.4%
0.53	4150	1.4%
0.63	4142	1.4%
0.61	4135	1.4%
Other values (98023)	252605	85.8%

Value	Count	Frequency (%)
0.1000105866	1	< 0.1%
0.1000275474	1	< 0.1%
0.100042766	1	< 0.1%
0.1000634659	1	< 0.1%
0.1001249456	1	< 0.1%
0.1001266003	1	< 0.1%
0.1001367821	1	< 0.1%
0.100158952	1	< 0.1%
0.1001924626	1	< 0.1%
0.1002099402	1	< 0.1%

Value	Count	Frequency (%)
98.5	1	< 0.1%
95.45	1	< 0.1%
91.8	1	< 0.1%
85.7	1	< 0.1%
80	1	< 0.1%
79.99	2	< 0.1%
79.98	1	< 0.1%
79.97974409	1	< 0.1%
79.97712437	1	< 0.1%
79.97	2	< 0.1%

traffic_signal_compliance
Real number (ℝ)

Distinct	155737
Distinct (%)	52.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	83.543748

Minimum	60
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.2 MiB

Quantile statistics

Minimum	60
5-th percentile	67.66
Q1	76.800438
median	84.13
Q3	90.880829
95-th percentile	97.196484
Maximum	100
Range	40
Interquartile range (IQR)	14.080392

Descriptive statistics

Standard deviation	9.096709
Coefficient of variation (CV)	0.10888558
Kurtosis	-0.69023871
Mean	83.543748
Median Absolute Deviation (MAD)	7.0306237
Skewness	-0.2792356
Sum	24606641
Variance	82.750115
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
88.67	68	< 0.1%
75.87	67	< 0.1%
84.12	67	< 0.1%
78.88	66	< 0.1%
77.57	66	< 0.1%
82.74	65	< 0.1%
93.06	65	< 0.1%
81.34	64	< 0.1%
91.86	64	< 0.1%
81.95	64	< 0.1%
Other values (155727)	293880	99.8%

Value	Count	Frequency (%)
60	4	< 0.1%
60.0039329	1	< 0.1%
60.00531304	1	< 0.1%
60.00720156	1	< 0.1%
60.00846571	1	< 0.1%
60.00981162	1	< 0.1%
60.01	9	< 0.1%
60.02	15	< 0.1%
60.02170809	1	< 0.1%
60.02333669	1	< 0.1%

Value	Count	Frequency (%)
100	7	< 0.1%
99.99964309	1	< 0.1%
99.99957006	1	< 0.1%
99.99806868	1	< 0.1%
99.99802115	1	< 0.1%
99.99781533	1	< 0.1%
99.9977555	1	< 0.1%
99.99761074	1	< 0.1%
99.99677493	1	< 0.1%
99.99656556	1	< 0.1%

parking_usage
Real number (ℝ)

Distinct	93626
Distinct (%)	31.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.980223

Minimum	0.20000562
Maximum	99.995049
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.2 MiB

Quantile statistics

Minimum	0.20000562
5-th percentile	0.36002423
Q1	0.67721426
median	48.275
Q3	64.8
95-th percentile	81.568237
Maximum	99.995049
Range	99.795043
Interquartile range (IQR)	64.122786

Descriptive statistics

Standard deviation	31.604507
Coefficient of variation (CV)	0.83213062
Kurtosis	-1.59478
Mean	37.980223
Median Absolute Deviation (MAD)	27.235
Skewness	-0.1226426
Sum	11186543
Variance	998.84486
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.52	776	0.3%
0.42	767	0.3%
0.44	765	0.3%
0.64	759	0.3%
0.65	758	0.3%
0.58	757	0.3%
0.63	756	0.3%
0.43	756	0.3%
0.73	753	0.3%
0.72	751	0.3%
Other values (93616)	286938	97.4%

Value	Count	Frequency (%)
0.2000056206	1	< 0.1%
0.2000212135	1	< 0.1%
0.2000234995	1	< 0.1%
0.200041553	1	< 0.1%
0.2000498934	1	< 0.1%
0.2001307583	1	< 0.1%
0.2001384275	1	< 0.1%
0.200146107	1	< 0.1%
0.2001508205	1	< 0.1%
0.2001517916	1	< 0.1%

Value	Count	Frequency (%)
99.99504885	1	< 0.1%
99.99025721	1	< 0.1%
99.98281545	1	< 0.1%
99.98116081	1	< 0.1%
99.97852416	1	< 0.1%
99.97775261	1	< 0.1%
99.97159879	1	< 0.1%
99.97141914	1	< 0.1%
99.95893732	1	< 0.1%
99.95189215	1	< 0.1%

pedestrian_cyclist_count
Real number (ℝ)

Distinct	24323
Distinct (%)	8.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2055.5193

Minimum	50
Maximum	7999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.2 MiB

Quantile statistics

Minimum	50
5-th percentile	111
Q1	374
median	1358
Q3	3551
95-th percentile	5565
Maximum	7999
Range	7949
Interquartile range (IQR)	3177

Descriptive statistics

Standard deviation	1902.5373
Coefficient of variation (CV)	0.92557502
Kurtosis	-0.52089011
Mean	2055.5193
Median Absolute Deviation (MAD)	1132
Skewness	0.77708713
Sum	6.0542444 × 10⁸
Variance	3619648.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	450	0.2%
97	440	0.1%
99	425	0.1%
98	425	0.1%
104	425	0.1%
101	416	0.1%
103	415	0.1%
94	410	0.1%
102	401	0.1%
96	396	0.1%
Other values (24313)	290333	98.6%

Value	Count	Frequency (%)
50	120	< 0.1%
51	135	< 0.1%
52	128	< 0.1%
53	138	< 0.1%
54	123	< 0.1%
55	113	< 0.1%
56	118	< 0.1%
57	117	< 0.1%
58	112	< 0.1%
59	132	< 0.1%

Value	Count	Frequency (%)
7999	4	< 0.1%
7998	2	< 0.1%
7997	2	< 0.1%
7996	3	< 0.1%
7995	4	< 0.1%
7994	2	< 0.1%
7993	2	< 0.1%
7992	2	< 0.1%
7990	3	< 0.1%
7989	1	< 0.1%

weather_conditions
Categorical

Distinct	13
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.3 MiB

Clear	104635
Rainy	62084
Cloudy	53800
Hazy	23898
Foggy	18694
Other values (8)	31425

Length

Max length	13
Median length	5
Mean length	5.3286661
Min length	3

Characters and Unicode

Total characters	1569484
Distinct characters	27
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Rainy
2nd row	Hazy
3rd row	Cloudy
4th row	Hazy
5th row	Hazy

Common Values

Value	Count	Frequency (%)
Clear	104635	35.5%
Rainy	62084	21.1%
Cloudy	53800	18.3%
Hazy	23898	8.1%
Foggy	18694	6.3%
Storm	11815	4.0%
Thunderstorms	7629	2.6%
Stormy	4727	1.6%
Dusty	3744	1.3%
Overcast	1296	0.4%
Other values (3)	2214	0.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
clear	104635	35.5%
rainy	62084	21.1%
cloudy	53800	18.3%
hazy	23898	8.1%
foggy	18694	6.3%
storm	11815	4.0%
thunderstorms	7629	2.6%
stormy	4727	1.6%
dusty	3744	1.3%
overcast	1296	0.4%
Other values (3)	2214	0.8%

Most occurring characters

Value	Count	Frequency (%)
a	192740	12.3%
y	167375	10.7%
C	158435	10.1%
l	158435	10.1%
r	137731	8.8%
e	113560	7.2%
o	97624	6.2%
n	70968	4.5%
u	65173	4.2%
i	63339	4.0%
Other values (17)	344104	21.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1569484	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	192740	12.3%
y	167375	10.7%
C	158435	10.1%
l	158435	10.1%
r	137731	8.8%
e	113560	7.2%
o	97624	6.2%
n	70968	4.5%
u	65173	4.2%
i	63339	4.0%
Other values (17)	344104	21.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1569484	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	192740	12.3%
y	167375	10.7%
C	158435	10.1%
l	158435	10.1%
r	137731	8.8%
e	113560	7.2%
o	97624	6.2%
n	70968	4.5%
u	65173	4.2%
i	63339	4.0%
Other values (17)	344104	21.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1569484	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	192740	12.3%
y	167375	10.7%
C	158435	10.1%
l	158435	10.1%
r	137731	8.8%
e	113560	7.2%
o	97624	6.2%
n	70968	4.5%
u	65173	4.2%
i	63339	4.0%
Other values (17)	344104	21.9%

roadwork_construction
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	287.8 KiB

False	171047
True	123489

Value	Count	Frequency (%)
False	171047	58.1%
True	123489	41.9%

	average_speed	congestion_level	environmental_impact	incident_reports	parking_usage	pedestrian_cyclist_count	public_transport_usage	road_capacity_utilization	roadwork_construction	traffic_signal_compliance	traffic_volume	travel_time_index	weather_conditions
average_speed	1.000	-0.252	0.001	-0.000	0.317	0.245	-0.047	0.121	0.096	-0.115	-0.019	-0.213	0.089
congestion_level	-0.252	1.000	0.219	0.016	0.085	0.126	0.139	0.170	0.055	0.071	0.290	0.145	0.109
environmental_impact	0.001	0.219	1.000	-0.053	0.271	0.047	0.276	0.194	0.255	0.032	0.346	0.040	0.135
incident_reports	-0.000	0.016	-0.053	1.000	-0.040	0.181	-0.147	-0.103	0.053	0.029	-0.109	0.083	0.066
parking_usage	0.317	0.085	0.271	-0.040	1.000	0.321	0.216	0.339	0.262	-0.161	0.137	-0.196	0.171
pedestrian_cyclist_count	0.245	0.126	0.047	0.181	0.321	1.000	-0.197	0.058	0.167	-0.057	-0.047	0.087	0.150
public_transport_usage	-0.047	0.139	0.276	-0.147	0.216	-0.197	1.000	0.139	0.183	0.024	0.231	-0.054	0.142
road_capacity_utilization	0.121	0.170	0.194	-0.103	0.339	0.058	0.139	1.000	0.270	-0.031	0.418	-0.124	0.145
roadwork_construction	0.096	0.055	0.255	0.053	0.262	0.167	0.183	0.270	1.000	0.096	0.276	0.074	0.123
traffic_signal_compliance	-0.115	0.071	0.032	0.029	-0.161	-0.057	0.024	-0.031	0.096	1.000	0.053	0.086	0.083
traffic_volume	-0.019	0.290	0.346	-0.109	0.137	-0.047	0.231	0.418	0.276	0.053	1.000	0.064	0.109
travel_time_index	-0.213	0.145	0.040	0.083	-0.196	0.087	-0.054	-0.124	0.074	0.086	0.064	1.000	0.109
weather_conditions	0.089	0.109	0.135	0.066	0.171	0.150	0.142	0.145	0.123	0.083	0.109	0.109	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	date	area_name	road_name	traffic_volume	average_speed	travel_time_index	congestion_level	road_capacity_utilization	incident_reports	environmental_impact	public_transport_usage	traffic_signal_compliance	parking_usage	pedestrian_cyclist_count	weather_conditions	roadwork_construction
0	2022-01-01	Gomti Nagar	Shaheed Path	18823	25.399547	3.22	52.727863	88.72	7	72.87	0.57	83.23	55.36	3867.0	Rainy	No
1	2022-01-01	Indira Nagar	Faizabad Road	7083	38.866577	2.95	48.715108	83.10	6	84.59	0.52	87.86	71.31	4730.0	Hazy	No
2	2022-01-01	Alambagh	Kanpur Road (NH-27)	37933	57.681344	2.29	62.929283	89.11	7	65.47	0.49	90.33	56.22	2783.0	Cloudy	No
3	2022-01-01	Rajajipuram	Hardoi Road	38707	56.897932	2.88	80.801755	53.37	0	64.75	0.73	82.63	50.69	2921.0	Hazy	Yes
4	2022-01-01	Arjunganj	Sultanpur Road	9699	54.219556	2.53	41.401158	80.78	3	56.76	0.62	94.67	68.88	3282.0	Hazy	Yes
5	2022-01-01	Mahanagar	Sitapur Road	39094	59.811240	3.35	25.137638	72.01	4	50.32	0.60	67.71	68.77	2427.0	Foggy	No
6	2022-01-01	Gomti Nagar Extension	Amar Shaheed Path	24534	44.664824	1.79	77.185650	65.68	3	58.43	0.47	90.98	75.66	4782.0	Cloudy	Yes
7	2022-01-01	Jankipuram	Ring Road	6480	51.339987	3.24	53.868130	71.91	9	52.17	0.43	85.77	60.70	2905.0	Hazy	Yes
8	2022-01-01	Hazratganj	Vidhan Sabha Marg	3112	22.423003	1.92	49.654428	53.05	1	79.86	0.74	95.08	63.67	4733.0	Foggy	Yes
9	2022-01-01	Gomti Nagar	Lohia Path	22401	47.711635	1.75	66.818595	65.60	5	81.82	0.71	69.11	59.74	1006.0	Cloudy	Yes

	date	area_name	road_name	traffic_volume	average_speed	travel_time_index	congestion_level	road_capacity_utilization	incident_reports	environmental_impact	public_transport_usage	traffic_signal_compliance	parking_usage	pedestrian_cyclist_count	weather_conditions	roadwork_construction
294526	2024-08-08	Hebbal	Ballari Road	10563	40.279142	1.383775	30.463408	49.487880	0	71.126	54.596361	96.481256	83.048212	187.0	Clear	No
294527	2024-08-09	Indiranagar	100 Feet Road	33339	24.925143	1.500000	100.000000	100.000000	1	116.678	13.559886	81.755320	53.851126	107.0	Clear	No
294528	2024-08-09	Indiranagar	CMH Road	37265	38.471768	1.500000	100.000000	100.000000	4	124.530	70.586370	64.668040	95.563755	112.0	Clear	No
294529	2024-08-09	Koramangala	Sony World Junction	27673	20.000000	1.500000	93.969031	100.000000	0	105.346	57.726520	88.795917	83.965889	96.0	Overcast	Yes
294530	2024-08-09	Koramangala	Sarjapur Road	58992	43.138451	1.500000	100.000000	100.000000	2	167.984	68.810804	69.859257	64.179922	101.0	Clear	No
294531	2024-08-09	Electronic City	Hosur Road	11387	23.440276	1.262384	35.871483	57.354487	1	72.774	21.523289	83.530352	97.898279	211.0	Fog	No
294532	2024-08-09	M.G. Road	Trinity Circle	36477	45.168429	1.500000	100.000000	100.000000	3	122.954	29.822312	60.738488	60.355967	95.0	Clear	No
294533	2024-08-09	M.G. Road	Anil Kumble Circle	42822	22.028609	1.500000	100.000000	100.000000	1	135.644	43.185905	85.321627	61.333731	110.0	Clear	No
294534	2024-08-09	Jayanagar	South End Circle	20540	52.254798	1.020520	72.639152	97.845527	2	91.080	44.416043	89.586947	79.197198	94.0	Clear	No
294535	2024-08-09	Yeshwanthpur	Yeshwanthpur Circle	14705	31.128967	1.048720	43.409821	77.734621	1	79.410	26.616725	80.778753	60.602672	201.0	Rain	No

Overview

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample